﻿<%@ Control Language="VB" AutoEventWireup="false" CodeFile="SearchTrainingRecord.ascx.vb" Inherits="WebForm_SelfManageTrainingRecord_SearchTrainingRecord" %>
<div align="center">
    <asp:Label ID="lblRegStatus" runat="server" Text="<%$ Resources:CheckStatus %>"></asp:Label>
    <asp:DropDownList ID="ddlRegStatus" runat="server" 
        DataSourceID="SqlDataSource1" DataTextField="Text" DataValueField="Value">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:connStr %>" 
        SelectCommand="SELECT [Value], [Text] FROM [CodeMapping] WHERE (([TableName] = @TableName) AND ([ColumnName] = @ColumnName))">
        <SelectParameters>
            <asp:Parameter DefaultValue="TrainingRegister" Name="TableName" Type="String" />
            <asp:Parameter DefaultValue="RegStatus" Name="ColumnName" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:Button ID="btnQuery" runat="server" Text="<%$ Resources:Query %>" />
</div>
<My:MyGridView ID="GV" SkinID="pager" runat="server" 
    AllowHoverSelect="False" MySortDirection="Ascending" 
    AutoGenerateColumns="False" EmptyDataText="<%$ Resources:EmptyData %>" 
    AllowHoverEffect="False" AllowPaging="True" AllowSorting="True" 
     DataSourceID="ObjectDataSource1">
    <Columns>
        <asp:BoundField DataField="GroupName" HeaderText="<%$ Resources:GroupName %>" 
            SortExpression="GroupName" />
        <asp:BoundField DataField="CourseTypeText" HeaderText="<%$ Resources:CourseTypeText %>" 
            SortExpression="CourseTypeText" />
        <asp:BoundField DataField="CourseName" HeaderText="<%$ Resources:CourseName %>" 
            SortExpression="CourseName" />
        <asp:BoundField DataField="RegStartDate" HeaderText="<%$ Resources:RegStartDate %>" 
            SortExpression="RegStartDate" DataFormatString="{0:d}" />
        <asp:BoundField DataField="RegEndDate" HeaderText="<%$ Resources:RegEndDate %>"
            SortExpression="RegEndDate" DataFormatString="{0:d}" />
        <asp:BoundField DataField="StartDate" HeaderText="<%$ Resources:StartDate %>"
            SortExpression="StartDate" DataFormatString="{0:d}" />
        <asp:BoundField DataField="EndDate" HeaderText="<%$ Resources:EndDate %>"
            SortExpression="EndDate" DataFormatString="{0:d}" />
        <asp:BoundField DataField="RegStatusText" HeaderText="<%$ Resources:RegStatusText %>" 
            SortExpression="RegStatusText" />
    </Columns>
</My:MyGridView>
            <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
    OldValuesParameterFormatString="original_{0}" SelectMethod="BLL_Select" 
    TypeName="BLL_SearchTrainingRecord">
                <SelectParameters>
                    <asp:Parameter Name="VolunteerId" Type="String" />
                    <asp:Parameter Name="RegStatus" Type="String" />
                </SelectParameters>
</asp:ObjectDataSource>

            

            